Labor Reporting

Tracking labor and burden allows for management of time sheets and accurate reporting on labor hours and costs. The Payroll Reporting area is used to display the hours employees have worked on a given production job or for services performed in a given time period, such as days, weeks, or months. The Job Reporting area is used to generate shift efficiency reports, which can be used to detail work performed by Work Center, Work Crew, Shift, etc.

Configuration

The following processes are required prior to performing labor reporting.

  • Labor groups will need to be created via Production > Maintenance > Labor Groups.
  • Workers need to be created via Production > Maintenance > Workers.
  • Operations and Work Centers will need to be created.
  • Time sheets need to be filled in and saved via Production > Payroll Timesheet.
  • Production should be entered against Jobs and attributed to a Work Center, Work Crew, Shop Area, Operation, and/or Shift, if using the Job Reporting options.

Process

Labor Reporting can be completed using both the Payroll Reporting and Job Reporting pre-filters. Each section offers multiple different reports so that every aspect of a Job, Worker, Shift, etc. can be analyzed and reported on.

Using Worker Burden

Labor burden is the actual cost to a company to employ a worker. This amount is in addition to the regular salary the worker receives. Labor burden costs include benefits that a company must, or chooses to, pay for workers included on their payroll, including but not limited to: pension costs, health and dental insurance, paid sick or holiday time, and any other benefits that a company provides an employee. In DEACOM, burden costs for employees is maintained in the "Burden" field of the Worker record.

Generating a Payroll Reporting report

  1. Navigate to Production > Payroll Reporting.
  2. Select one of the report options via the "Report Type" field. Labor can be tracked by the various reports available. See the link in step #1 for additional information.
  3. Apply any filters necessary to find the pertinent data for reporting purposes such as a date range, or specific Labor Group. For non-standard filters, users can apply an advanced filter prior to running reports.
  4. Click the "View" button to display the report.
  5. Once the report form has is displayed, you can subtotal, sort, or filter the data further. The result set can be exported to Excel as needed. See Basic Objects and User Interface for more information.

Note: Time entries may be modified by users with the appropriate access. In addition, time scrubbing may be applied via the "Scrub Time" button when running the Payroll Shift report. See Time Scrubbing for additional information.

Generating a Shift Efficiency report

Shift Efficiency reports are useful in detailing the hours worked per Job. The detail can be as high-level as the Shop Area where the work was performed, or as detailed as the Shift that produced on the Job. To run a report:

  1. Navigate to Production > Job Reporting.
  2. Select "Production Cost" as the Report type, enter any other desired filters, then click "View".
  3. Choose how the report results should be grouped by selecting the desired item on the left-hand section of the form and clicking "Move" to move it to the right-hand section of the form. If all items will be used to group results, click "Move All". Keep in mind, the results will be grouped in the order listed. Once satisfied with the selections made, click "Continue" to generate the report.

FAQ & Diagnostic Tips

My payroll detail report will not export into Excel. The following message appears: The Input mask '99:99' for the 'j3_modt1' column evaluated to '##:##' which Excel could not process as a numeric format.

Excel cannot interpret a number containing a colon. The time in and time out fields can be formatted as strings and then Excel can handle them. Modify the grid layout and change the j3_modt1 and j3_modt2 fields to a User-defined expression similar to the example below:

CAST(TRANSFORM(j3_modt1,"99:99") AS VARCHAR(5))

Alternatively, you can simply remove the 99:99 from the Input mask which would display the times as simple numbers.

Tip: The following calculation variables have been added to the Job Cost Summary report via Production > Job Reporting in order to define and separate the burden costs provided from operations versus those provided by workers : StanBurOp, BurCost, BurCostWorker, and BurCostOp. Additional information including the calculation details are available via the link above.

Tip: The "calchours" variable, available to the Job Payroll Shift and Job Payroll Summary reports, allows users to easily see what time workers will be paid for. The variable is the SUM of the calculated rate (j3_calctime) for all job time entries (dtjob3). Note that j3_calctime is calculated as (j3_timeout – j3_timein) * (j3_rate/pt_rate)

Tip: The calculation for j3_splithours is the number of hours a worker was on a job divided by the number of jobs the worker was logged into.

Tip: Burden rate fields are available to many of the reports in Payroll Reporting. These fields are pt_burdenrate and j3_burdenrate. Pt_burdenrate represents the burden rate indicated on the worker record via Production > Maintenance > Workers. J3_burdenrate is populated with the worker's burden rate, the operation's burden rate, or both, depending on the value specified in the "Burden Posting Type" field in Accounting Options.